Plot the transit route's line geom.
/opt/conda/lib/python3.10/site-packages/geopandas/_compat.py:112: UserWarning: The Shapely GEOS version (3.10.3-CAPI-1.16.1) is incompatible with the GEOS version PyGEOS was compiled with (3.10.1-CAPI-1.16.0). Conversions between both will be slow. warnings.warn(
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 261 | 120 | 0.200 |
| 1 | 159 | 2042 | 0.071 |
| 2 | 18 | 1 | 0.000 |
| 3 | 18 | 18689 | 0.000 |
| 4 | 18 | 33023 | 0.000 |
| 5 | 18 | 8 | 0.000 |
| 6 | 18 | 822 | 0.000 |
| 7 | 159 | 2017 | 0.000 |
| 8 | 159 | 2031 | 0.000 |
| 9 | 159 | 2033 | 0.000 |
| 10 | 159 | 2041 | 0.000 |
| 11 | 261 | 116 | 0.000 |
| 12 | 261 | 117 | 0.000 |
| 13 | 261 | 118 | 0.000 |
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 344 | 178 | 0.25 |
| 1 | 82 | 153 | 0.00 |
| 2 | 82 | 157 | 0.00 |
| 3 | 82 | 161 | 0.00 |
| 4 | 82 | 1885 | 0.00 |
| 5 | 82 | 1886 | 0.00 |
| 6 | 82 | 1887 | 0.00 |
| 7 | 82 | 6446 | 0.00 |
| 8 | 82 | 6460 | 0.00 |
| 9 | 82 | 6790 | 0.00 |
| 10 | 162 | 552 | 0.00 |
| 11 | 162 | 554 | 0.00 |
| 12 | 344 | 181 | 0.00 |
| 13 | 344 | 288 | 0.00 |
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 331 | ML | 0.222 |
| 1 | 376 | 474 | 0.167 |
| 2 | 251 | 11115 | 0.067 |
| 3 | 273 | 015 | 0.054 |
| 4 | 48 | 9e53fec4-40e0-4b85-8984-fc8f9c4fae97 | 0.042 |
| 5 | 48 | 405c1242-7e26-4b0d-b071-8d82d8ea1675 | 0.040 |
| 6 | 48 | 3bea0a4c-dc0f-493c-869e-97d6e8384cd2 | 0.000 |
| 7 | 372 | 46c8ab4f-27df-422a-b0b5-9c50275c2588 | 0.000 |
| 8 | 372 | 07320499-ab75-48c5-99c7-5967c4b22f1b | 0.000 |
| 9 | 372 | 1b9912ea-a0f8-46d1-a45b-768dbbc96187 | 0.000 |
| 10 | 372 | 1c17bb5c-1a20-4427-a01f-d5158c5cc5e2 | 0.000 |
| 11 | 372 | 3bc003ec-9243-4b49-a873-e0884b5e6ff7 | 0.000 |
| 12 | 372 | ad7444fd-3e73-4a75-b2dc-68413b6dc649 | 0.000 |
| 13 | 372 | 8bebc5d1-8c71-4646-9b43-6513d4589bae | 0.000 |
| 14 | 331 | Hwy267 | 0.000 |
| 15 | 372 | b6e92239-4632-47de-8ef8-2515e1ef4b1e | 0.000 |
| 16 | 372 | f7e6fe88-8770-4143-886b-333f0aa0a498 | 0.000 |
| 17 | 376 | 472 | 0.000 |
| 18 | 376 | 473 | 0.000 |
| 19 | 376 | 6463 | 0.000 |
| 20 | 331 | Hwy89 | 0.000 |
| 21 | 273 | 210 | 0.000 |
| 22 | 273 | 226 | 0.000 |
| 23 | 251 | 11121 | 0.000 |
| 24 | 48 | 4d36ef15-19a7-45ee-bbb1-f4a4a59535ab | 0.000 |
| 25 | 48 | 9a811a91-b5fb-46cb-b5d9-cb197ce54762 | 0.000 |
| 26 | 48 | ab418467-7749-4421-8043-6a0edbb22098 | 0.000 |
| 27 | 48 | ce46f4b9-eec4-4a83-bd50-50ac486428db | 0.000 |
| 28 | 251 | 11117 | 0.000 |
| 29 | 251 | 11119 | 0.000 |
| 30 | 273 | 103 | 0.000 |
| 31 | 273 | 211 | 0.000 |
| 32 | 273 | 109 | 0.000 |
| 33 | 273 | 138 | 0.000 |
| 34 | 273 | 171 | 0.000 |
| 35 | 273 | 174 | 0.000 |
| 36 | 273 | 180 | 0.000 |
| 37 | 273 | 182 | 0.000 |
| 38 | 376 | 6464 | 0.000 |
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 368 | J | 0.245 |
| 1 | 127 | 172 | 0.222 |
| 2 | 194 | 2303 | 0.217 |
| 3 | 290 | 278-196 | 0.214 |
| 4 | 290 | 278 | 0.214 |
| ... | ... | ... | ... |
| 98 | 70 | 1050 | 0.000 |
| 99 | 70 | 1031 | 0.000 |
| 100 | 70 | 1029 | 0.000 |
| 101 | 70 | 1028 | 0.000 |
| 102 | 368 | Lynx | 0.000 |
103 rows × 3 columns
| calitp_itp_id | route_id | mean_speed_mph | |
|---|---|---|---|
| 0 | 4 | 19 | 8.44 |
| 1 | 4 | 72M | 9.50 |
| 2 | 4 | 1T | 10.02 |
| 3 | 4 | 72 | 10.32 |
| 4 | 4 | 10 | 10.61 |
| 5 | 4 | 72R | 11.31 |
| 6 | 127 | 114 | 11.99 |
| 7 | 218 | S | 12.01 |
| 8 | 4 | 667 | 13.42 |
| 9 | 127 | 132 | 13.56 |
| 10 | 4 | 631 | 13.78 |
| 11 | 4 | 802 | 14.02 |
| 12 | 4 | 676 | 14.21 |
| 13 | 218 | 11X | 14.53 |
| 14 | 218 | 10 | 15.68 |
| 15 | 4 | 682 | 15.77 |
| 16 | 4 | 604 | 16.12 |
| 17 | 127 | 130 | 16.32 |
| 18 | 4 | 232 | 16.33 |
| 19 | 4 | 606 | 16.62 |
| 20 | 4 | G | 17.04 |
| 21 | 4 | FS | 17.27 |
| 22 | 127 | 154-234 | 17.88 |
| 23 | 4 | L | 18.29 |
| 24 | 127 | 150-234 | 18.85 |
| 25 | 4 | W | 19.06 |
| 26 | 4 | LA | 19.24 |
| 27 | 4 | O | 19.56 |
| 28 | 4 | NX | 19.75 |
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 296 | 69A | 0.250 |
| 1 | 208 | 093 | 0.200 |
| 2 | 208 | 084 | 0.200 |
| 3 | 208 | 092 | 0.200 |
| 4 | 208 | 091 | 0.200 |
| 5 | 289 | 9N | 0.188 |
| 6 | 289 | 9S | 0.167 |
| 7 | 473 | 65513 | 0.167 |
| 8 | 296 | 17 | 0.133 |
| 9 | 296 | 91X | 0.067 |
| 10 | 296 | 69W | 0.065 |
| 11 | 296 | WC | 0.000 |
| 12 | 312 | ROUTEA | 0.000 |
| 13 | 312 | ROUTEB | 0.000 |
| 14 | 296 | 79 | 0.000 |
| 15 | 296 | 75 | 0.000 |
| 16 | 473 | 63257 | 0.000 |
| 17 | 296 | 42 | 0.000 |
| 18 | 129 | 3278 | 0.000 |
| 19 | 289 | 14S | 0.000 |
| 20 | 208 | 011 | 0.000 |
| 21 | 289 | 12S | 0.000 |
| 22 | 289 | 12N | 0.000 |
| 23 | 289 | 10S | 0.000 |
| 24 | 289 | 10N | 0.000 |
| 25 | 208 | 923 | 0.000 |
| 26 | 208 | 075 | 0.000 |
| 27 | 208 | 028 | 0.000 |
| 28 | 208 | 023 | 0.000 |
| 29 | 208 | 020 | 0.000 |
| 30 | 289 | 14N | 0.000 |
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 146 | 1368 | 0.250 |
| 1 | 346 | 12182 | 0.250 |
| 2 | 146 | 1167 | 0.167 |
| 3 | 146 | 1367 | 0.167 |
| 4 | 146 | 1163 | 0.154 |
| 5 | 146 | 1166 | 0.154 |
| 6 | 346 | 12183 | 0.042 |
| 7 | 126 | 81 | 0.000 |
| 8 | 346 | 12176 | 0.000 |
| 9 | 474 | T11 | 0.000 |
| 10 | 474 | P6 | 0.000 |
| 11 | 474 | C40 | 0.000 |
| 12 | 346 | 12187 | 0.000 |
| 13 | 346 | 12181 | 0.000 |
| 14 | 188 | 577 | 0.000 |
| 15 | 188 | 579 | 0.000 |
| 16 | 188 | 578 | 0.000 |
| 17 | 126 | 92 | 0.000 |
| 18 | 146 | 1175 | 0.000 |
| 19 | 146 | 1173 | 0.000 |
| 20 | 146 | 1162 | 0.000 |
| 21 | 146 | 1161 | 0.000 |
| 22 | 474 | T7 | 0.000 |
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 231 | 4778 | 0.138 |
| 1 | 295 | 799 | 0.100 |
| 2 | 231 | 3404 | 0.062 |
| 3 | 183 | 31 | 0.053 |
| 4 | 183 | 30 | 0.042 |
| ... | ... | ... | ... |
| 88 | 183 | 4278 | 0.000 |
| 89 | 183 | 28 | 0.000 |
| 90 | 183 | 1524 | 0.000 |
| 91 | 183 | 1458 | 0.000 |
| 92 | 380 | 11693 | 0.000 |
93 rows × 3 columns
| calitp_itp_id | route_id | mean_speed_mph | |
|---|---|---|---|
| 0 | 183 | 708 | 8.44 |
| 1 | 170 | 175 | 8.57 |
| 2 | 183 | 26 | 8.80 |
| 3 | 170 | 171 | 9.50 |
| 4 | 170 | 174 | 10.66 |
| 5 | 183 | 28 | 11.15 |
| 6 | 183 | 30 | 11.25 |
| 7 | 183 | 858 | 12.12 |
| 8 | 182 | 232-13159 | 12.18 |
| 9 | 183 | 1524 | 12.29 |
| 10 | 183 | 31 | 12.76 |
| 11 | 183 | 868 | 13.18 |
| 12 | 183 | 856 | 13.69 |
| 13 | 182 | 150-13159 | 13.94 |
| 14 | 183 | 4291 | 14.18 |
| 15 | 183 | 1458 | 15.56 |
| 16 | 182 | 177-13159 | 16.17 |
| 17 | 295 | 627 | 16.29 |
| 18 | 183 | 27 | 16.40 |
| 19 | 183 | 869 | 16.49 |
| 20 | 183 | 4290 | 16.49 |
| 21 | 182 | 487-13159 | 16.53 |
| 22 | 182 | 550-13159 | 16.61 |
| 23 | 182 | 460-13159 | 16.72 |
| 24 | 182 | 501-13159 | 17.20 |
| 25 | 183 | 867 | 17.26 |
| 26 | 182 | 344-13159 | 17.49 |
| 27 | 183 | 4278 | 17.76 |
| 28 | 183 | 870 | 18.66 |
| 29 | 295 | 799 | 19.24 |
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 360 | 3206 | 0.238 |
| 1 | 232 | 10396 | 0.215 |
| 2 | 232 | 10415 | 0.162 |
| 3 | 232 | 10418 | 0.100 |
| 4 | 269 | 79 | 0.091 |
| 5 | 269 | 28 | 0.052 |
| 6 | 269 | 27 | 0.032 |
| 7 | 34 | 11662 | 0.000 |
| 8 | 360 | 19747 | 0.000 |
| 9 | 360 | 3205 | 0.000 |
| 10 | 360 | 3240 | 0.000 |
| 11 | 360 | 3220 | 0.000 |
| 12 | 360 | 19745 | 0.000 |
| 13 | 360 | 3381 | 0.000 |
| 14 | 360 | 3382 | 0.000 |
| 15 | 360 | 3394 | 0.000 |
| 16 | 360 | 19746 | 0.000 |
| 17 | 269 | 31 | 0.000 |
| 18 | 360 | 19744 | 0.000 |
| 19 | 360 | 19739 | 0.000 |
| 20 | 34 | 1381 | 0.000 |
| 21 | 269 | 206 | 0.000 |
| 22 | 269 | 205 | 0.000 |
| 23 | 269 | 204 | 0.000 |
| 24 | 269 | 200 | 0.000 |
| 25 | 232 | 10406 | 0.000 |
| 26 | 232 | 10401 | 0.000 |
| 27 | 34 | 16684 | 0.000 |
| 28 | 360 | 5137 | 0.000 |
| calitp_itp_id | route_id | mean_speed_mph | |
|---|---|---|---|
| 0 | 269 | 79 | 15.66 |
| 1 | 269 | 28 | 18.04 |
| 2 | 269 | 27 | 18.99 |
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 99 | 561 | 0.25 |
| 1 | 99 | 562 | 0.00 |
| 2 | 99 | 563 | 0.00 |
| 3 | 99 | 566 | 0.00 |
| 4 | 99 | 765 | 0.00 |
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 343 | 19 | 0.182 |
| 1 | 11 | 570 | 0.125 |
| 2 | 484 | 32 | 0.030 |
| 3 | 11 | 569 | 0.000 |
| 4 | 343 | 972 | 0.000 |
| 5 | 484 | 38 | 0.000 |
| 6 | 484 | 37 | 0.000 |
| 7 | 484 | 34 | 0.000 |
| 8 | 484 | 30 | 0.000 |
| 9 | 484 | 29 | 0.000 |
| 10 | 484 | 28 | 0.000 |
| 11 | 484 | 25 | 0.000 |
| 12 | 484 | 24 | 0.000 |
| 13 | 484 | 20 | 0.000 |
| 14 | 484 | 19 | 0.000 |
| 15 | 484 | 17 | 0.000 |
| 16 | 343 | 958 | 0.000 |
| 17 | 343 | 1881 | 0.000 |
| 18 | 343 | 1211 | 0.000 |
| 19 | 343 | 1210 | 0.000 |
| 20 | 284 | 95 | 0.000 |
| 21 | 284 | 91 | 0.000 |
| 22 | 284 | 90 | 0.000 |
| 23 | 284 | 163 | 0.000 |
| 24 | 284 | 152 | 0.000 |
| 25 | 284 | 150 | 0.000 |
| 26 | 11 | 661 | 0.000 |
| 27 | 11 | 573 | 0.000 |
| 28 | 11 | 571 | 0.000 |
| 29 | 484 | 4 | 0.000 |
| calitp_itp_id | route_id | mean_speed_mph | |
|---|---|---|---|
| 0 | 484 | 28 | 10.42 |
| 1 | 484 | 4 | 12.87 |
| 2 | 484 | 17 | 12.99 |
| 3 | 484 | 20 | 14.75 |
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 278 | 905 | 0.082 |
| 1 | 278 | 25 | 0.077 |
| 2 | 278 | 235 | 0.038 |
| 3 | 278 | 110 | 0.000 |
| 4 | 278 | 894 | 0.000 |
| 5 | 278 | 974 | 0.000 |
| 6 | 278 | 950 | 0.000 |
| 7 | 278 | 904 | 0.000 |
| 8 | 278 | 901 | 0.000 |
| 9 | 278 | 60 | 0.000 |
| 10 | 278 | 816 | 0.000 |
| 11 | 278 | 140 | 0.000 |
| 12 | 278 | 290 | 0.000 |
| 13 | 278 | 280 | 0.000 |
| 14 | 278 | 225 | 0.000 |
| 15 | 278 | 20 | 0.000 |
| 16 | 386 | 21 | 0.000 |
| calitp_itp_id | route_id | pct_trips_competitive | |
|---|---|---|---|
| 0 | 142 | 89 | 0.111 |
| 1 | 142 | 29 | 0.044 |
| 2 | 142 | 529 | 0.000 |
| 3 | 142 | 83 | 0.000 |